<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/chiptrack-tags.tld" prefix="chiptrack" %>

<chiptrack:checkLogon sourcePage="/uploadForecast.do"/>

<%@ page import="java.util.ArrayList,
                java.util.HashMap,
                java.util.Iterator,
                com.scalar.chiptrack.users.User,
                com.scalar.chiptrack.users.UserGroup,
                com.scalar.chiptrack.marketing.MarketingForecast,
                com.scalar.chiptrack.marketing.dao.MarketingDAO,
                com.scalar.chiptrack.commons.SessionKeys,
                com.scalar.chiptrack.utils.StringUtils,
                com.scalar.chiptrack.utils.ConfigManager,
                 java.util.Calendar"%>

<HTML><HEAD><TITLE>Scalarsoft - ChipTrac</TITLE>

<%String chipTracContext = "/" + ConfigManager.getChipTracContext();%>

<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<LINK href="<%=chipTracContext%>/jsp/includes/stylesheets/scalarsoft.css" type="text/css" rel=stylesheet>

<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY bgColor="#ffffff" leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<SCRIPT language="JavaScript" src="<%=chipTracContext%>/jsp/includes/scripts/validations.js">
</script>

<SCRIPT language="JavaScript">
function closeWindow(form) {

	    window.close();
}
</script>
<table cellpadding="10" cellspacing="0" border="0" width="100%">
<tr bgcolor="#8C87A8">
    <td height="30" valign="top" align=center><font class="NArialW">
        <font color="#FFFFFF">Marketing Forecast File Upload</font><br>
    </td>
    <td valign="top" align="right">
        <a href="javascript:window.close()" onMouseOver="window.status='Click here to close this window';return true" onmouseout="window.status='';return true" ><font class="NArial">Close</font></a>
    </td>
</tr>
</table>

<html:form method="post" action="/uploadForecast.do?action=upload" enctype="multipart/form-data" name="settingForecastForm" type="com.scalar.chiptrack.marketing.forms.SettingForecastForm">

<img src="<%=chipTracContext%>/jsp/includes/images/spacer.gif" height=20>
<table>
 <tr><td colspan=5><chiptrack:info styleClass="NArialL"/></td></tr>
 <tr><td colspan=5><chiptrack:errors styleClass="NArialL"/></td></tr>
 </table>
 <table border="0" width="90%"  class='NArialL' align=center>
 <tr><td>
 <table border="0" width="100%" bordercolor="black">
 <tr colspan=2><td><font class='NArialL'>Upload File:</font></td>
 <td  align="left"><html:file styleClass="txfield" name="settingForecastForm" property="theFile"></html:file>
 </td></tr>
 <tr colspan=2><td><font class='NArialL' size="1">(Upload Microsoft Excel(.xls) File Only)</font></td>
 </tr></table>
 <tr align="center" colspan=2>
 <td >
 <html:submit value="Upload" styleClass="button"></html:submit>
 </td></tr>

 </td></tr>
 <tr><td><img src="<%=chipTracContext%>/jsp/includes/images/spacer.gif" height=40></td></tr>

 <tr><td><font class="NArialL">The Excel file Should be in the following format:</font></td></tr>
 <tr><td>
 <table border="1" cellspacing=0 width="100%">
 <tr>
 <td><font class="NArialL">CustomerCode</td>
 <td><font class="NArialL">PartNumber</td>
 <td><font class="NArialL">MonthDate</td>
 <td><font class="NArialL">Units</td>
 <td><font class="NArialL">UnitPrice</td>
 </tr>
 <tr>
 <td class="bodytext">CUS00023 </td>
 <td class="bodytext">PW1231A</td>
 <td class="bodytext">7/1/2004</td>
 <td class="bodytext">1100</td>
 <td class="bodytext">10.25</td>
 </tr>
 </table>
 </td></tr>
 <tr><td>
 <img src="<%=chipTracContext%>/jsp/includes/images/spacer.gif" height=40>
 <table border="0" width="50%" bordercolor="black" align="right">
 <tr><td colspan='5' align=right><a href="javascript:closeWindow(document.settingForecastForm);" onMouseOver="window.status='Click here to close this window';return true" onmouseout="window.status='';return true"><font class='NArialL'>Close this window</font></a></td></tr>
 </table>
 </td></tr>
 </table>
 </html:form>


</BODY>
</HTML>
